UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yrj2egfHaX5wn19b/4tqruOKbu+AS9Rqed7tLDvdAHI='
WHERE
key_id = 'a0c9c60e9922984ae0233b4c99762acfdd9b28398e1fe0abf752f92aa43b94b3'
AND (
token = 'Yrj2egfHaX5wn19b/4tqruOKbu+AS9Rqed7tLDvdAHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)