UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zjb5sk2qRbycSxMJxB91molnw+n7T2hQwurFk/nTKE='
WHERE
key_id = 'd52bbb2b838bd27241ab8faca9508ff7810df03980787fd96f93ab9ea39802fb'
AND (
token = '9zjb5sk2qRbycSxMJxB91molnw+n7T2hQwurFk/nTKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)