UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J0odukPC7uiigCeB8RygtDRZrqpX9xq8NxAd+Mm6vMI='
WHERE
key_id = 'd5a6b2ead9de34fc6c51cbbd53bb2d94824aa195253fedf5e71d718a92fc922a'
AND (
token = 'J0odukPC7uiigCeB8RygtDRZrqpX9xq8NxAd+Mm6vMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)