UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3PzgtGF1mcnsARyCYJYuK00zmQisHJL8zNQEgQrUbLs='
WHERE
key_id = '41bdc499f81636a7f19bd2a8aea0e8a464fd8c7ef0e29311aa14fe64dfda0420'
AND (
token = '3PzgtGF1mcnsARyCYJYuK00zmQisHJL8zNQEgQrUbLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)