UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPLm4KzwIo/HnQxzgVFblGd+jwIVACj62KVM1uLUsiI='
WHERE
key_id = 'c8d27a0fe74764cb8cb34a37581f4d67b315d53d2e674eb4f730f4049d919b56'
AND (
token = 'qPLm4KzwIo/HnQxzgVFblGd+jwIVACj62KVM1uLUsiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)