UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/meXACfelTgFXqu/xZoiSNRLf2Cqip788rr4/jIVVk='
WHERE
key_id = 'b9eae496d3b9c914257c3216b3a275e6492e8ae91fa0fa07d129d5ee89bf0522'
AND (
token = 'v/meXACfelTgFXqu/xZoiSNRLf2Cqip788rr4/jIVVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)