UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OqO8QtXPk4165yP3ZWaQOjiyqTaykdRD3qN+esLCL0s='
WHERE
key_id = '0267aa443192c03004f4a665c166aadc25d595fba996b16203510f9a22b56ee4'
AND (
token = 'OqO8QtXPk4165yP3ZWaQOjiyqTaykdRD3qN+esLCL0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)