UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjYxLB6vXy0W3xjKlDpbUt79expwY39MUrtIB4gIeY4='
WHERE
key_id = '07d2a710646743405789ab9f18d3228260cb20ad5bb5bff46574c578cd046086'
AND (
token = 'hjYxLB6vXy0W3xjKlDpbUt79expwY39MUrtIB4gIeY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)