UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xS5V8jyCwGf0XN0x7TLLdytrWqfRkRUaKokRQ8ng45w='
WHERE
key_id = '2891982d3062b0b59060e88643826272f38881c332f670d3387dc54d509ebb2f'
AND (
token = 'xS5V8jyCwGf0XN0x7TLLdytrWqfRkRUaKokRQ8ng45w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)