UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pAfVIsfxVqHznPG/2gELUo344AYtZYT2Up8AxLkZHos='
WHERE
key_id = 'd0bd99adf5774e261e981d296ee8aeb197461e0d54c335883ac0e08493b70b7c'
AND (
token = 'pAfVIsfxVqHznPG/2gELUo344AYtZYT2Up8AxLkZHos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)