UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00y7e7qd/EgUZGWy5DUlp5dfmWkJPZXK71jUeuzZjC0='
WHERE
key_id = '6ad0efcdf3c02c59143cdcbe7de42f64049060e2e2b684b4bd7226e4cc0a27a3'
AND (
token = '00y7e7qd/EgUZGWy5DUlp5dfmWkJPZXK71jUeuzZjC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)