UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDzKpswv6J45pZk298I1MA8zUNMoypENs3l6W1qo+W8='
WHERE
key_id = '40c6dfa16b826cb30472375c88b2a62f50ea90565ecfff2b2652bd3579d16d48'
AND (
token = 'pDzKpswv6J45pZk298I1MA8zUNMoypENs3l6W1qo+W8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)