UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QreTolxhDFTTIA9kZt8c+Zox+9iIDv9X/jP+ouwXRDs='
WHERE
key_id = 'f05a6146496f2054fa29aea52c262bf718e33909bc7b34a4eea548ae1222805f'
AND (
token = 'QreTolxhDFTTIA9kZt8c+Zox+9iIDv9X/jP+ouwXRDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)