UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pxgrQlZXD1QgMIHo8RtMlOOdRN9atGqYgqKg18mX3aA='
WHERE
key_id = '283e7c2efcff6441cf2c965da742b48eb8e1f7814e052576194220a0939b69c4'
AND (
token = 'pxgrQlZXD1QgMIHo8RtMlOOdRN9atGqYgqKg18mX3aA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)