UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGD0IhipUpQZXsoe/cst8TZx/BJLfrNUjC0EMEFhgfQ='
WHERE
key_id = '305d40cb227ac6f3dbb8e1f65b67cd45597ff7d282d46fdecab80416932fd3fb'
AND (
token = 'SGD0IhipUpQZXsoe/cst8TZx/BJLfrNUjC0EMEFhgfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)