UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0EmfQRE/VBRleBRtjHkOQUdknBroZrV2uy9nFlr3uyo='
WHERE
key_id = 'ac5a8b76762d2cbe4f4643b1922d61e00df9e19425db5c4da27b0d75ca5f1507'
AND (
token = '0EmfQRE/VBRleBRtjHkOQUdknBroZrV2uy9nFlr3uyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)