UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3C0unj3tyDr04sfitjK+z1AVB6NyDmtOGcXJEdqVWsw='
WHERE
key_id = '7c711375aa9c47be0d008577e85f1346b17fbbf63225810b10596f86ea1aad19'
AND (
token = '3C0unj3tyDr04sfitjK+z1AVB6NyDmtOGcXJEdqVWsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)