UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DgqfvMeHQc+aUNbzzkz599KLx4Wq1y02dNTaf+PnDJ8='
WHERE
key_id = 'c452639684930e084855f267bd1676f473852caa811c570a3ccf2ffffb1930be'
AND (
token = 'DgqfvMeHQc+aUNbzzkz599KLx4Wq1y02dNTaf+PnDJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)