UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lTiIBjm4yKZbj2i93XHeNjy3w03jLxb5+ADa3pfBtc='
WHERE
key_id = '500ebe715b8b2029c86fdaf2dccda451886544685e4fa7d2ba2f44d7b3d00082'
AND (
token = '/lTiIBjm4yKZbj2i93XHeNjy3w03jLxb5+ADa3pfBtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)