UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KcIva+1jK1Nzx7aZDbdA8YbZVhGdicyK3D72eKdDwfo='
WHERE
key_id = '4ac1aef139bc169d220061b9257a16cabeb21d099490bf354acb0b913de16ab2'
AND (
token = 'KcIva+1jK1Nzx7aZDbdA8YbZVhGdicyK3D72eKdDwfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)