UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aTBafKXJsh3l9VhzVSdLpCd2jsOzREmExaSo3NxgOPI='
WHERE
key_id = 'c00a716978f7c1138a63a7092af72f07a5f3547e121bcf294b801f7930835c15'
AND (
token = 'aTBafKXJsh3l9VhzVSdLpCd2jsOzREmExaSo3NxgOPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)