UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DafVWHdWCV3iE48x0UbGoHEfv34izIUOsnh5KAQC9MI='
WHERE
key_id = '1c4a12e161290fcb226749ae4625066a0c317c149bca9f2ed8e6ccc58949c5d9'
AND (
token = 'DafVWHdWCV3iE48x0UbGoHEfv34izIUOsnh5KAQC9MI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)