UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VgUhIyeBibpG2JbIDnG/Fj0muWE3z7fcym6zJmVDJAg='
WHERE
key_id = 'bd55d47ee642a170f56aac445ce1470e6786bd6f778529a1244d37cb8b68fcbc'
AND (
token = 'VgUhIyeBibpG2JbIDnG/Fj0muWE3z7fcym6zJmVDJAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)