UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDUzsrA7NJrm0fPb25ySUN64Edz1OjLcTjYSRjUaOok='
WHERE
key_id = '28d0c602adc9f85e46edea6256b680b4e230f0a8dc6525f3853a746aa28ee872'
AND (
token = 'ZDUzsrA7NJrm0fPb25ySUN64Edz1OjLcTjYSRjUaOok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)