UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WrbalA1qZSkmqkRODiXUbFsw7k9OAA8SY46ykq3RSI='
WHERE
key_id = 'd182b3837f2fbe0d17220067e2bc7f192456be8d17b72bdb462d9f98a781a4f2'
AND (
token = '6WrbalA1qZSkmqkRODiXUbFsw7k9OAA8SY46ykq3RSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)