UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8zy/pS03anV5uAQYWuDbh5o2dMg2OdQL+DoDY1Ismw='
WHERE
key_id = 'aa91b12db2e7b511716a2923222c9e78ff2e6a7137d4bbbd4c01a66a688e2fc5'
AND (
token = 'P8zy/pS03anV5uAQYWuDbh5o2dMg2OdQL+DoDY1Ismw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)