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