UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmDDDVSbHgZwtNJbpse1um6rTwesA2Ayq/vEWN0ndc4='
WHERE
key_id = 'd86ec9e36ebd27e8774015a3be11e4f941376c1692a0fb073b2a4969439eb5be'
AND (
token = 'XmDDDVSbHgZwtNJbpse1um6rTwesA2Ayq/vEWN0ndc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)