UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGX5CyMpUvm2180QTE3GBKqDEPJ0VwSGN1GE3Dzmqic='
WHERE
key_id = '4ec31cb46a9c1a1430f6f65823119612678fb2ac7296b9b132e38e101a3060ef'
AND (
token = 'pGX5CyMpUvm2180QTE3GBKqDEPJ0VwSGN1GE3Dzmqic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)