UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDHWkdDFZ+baltx3wjqlZzfxsCimdlJUJxp//BjSn7M='
WHERE
key_id = 'b1cf001cfb5f285ef4bada0ad1f8a89894e845abbefd891502dccbc5275e76b3'
AND (
token = 'CDHWkdDFZ+baltx3wjqlZzfxsCimdlJUJxp//BjSn7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)