UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5I/4rIh37kYuvB36YQR11XiDnprOxCGrjLpMG7I541g='
WHERE
key_id = '3a7781954183668e10886692138b79763abc77437573f58d3b193f523d2b3606'
AND (
token = '5I/4rIh37kYuvB36YQR11XiDnprOxCGrjLpMG7I541g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)