UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pvj+xcDQCjidF78ZYMPW1B0+7yZSv9RQlQGoCEeEMPA='
WHERE
key_id = '4e550c917cff0722b82b63f48b6ed1817a5bf499d727f411ad0e4e4789deee77'
AND (
token = 'Pvj+xcDQCjidF78ZYMPW1B0+7yZSv9RQlQGoCEeEMPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)