UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tg5SOudhVD8XchCj1LBG3mj31iqKntehUlA2z7esKC0='
WHERE
key_id = '0c16526ac87f1f6ec3613f5a9ce8a8e24594a01363308bd9bedc6708ad76c1d9'
AND (
token = 'Tg5SOudhVD8XchCj1LBG3mj31iqKntehUlA2z7esKC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)